create procedure [dbo].[BAEEventSetupGetChosenFunctions] @groupName varchar(40),
     @eventCode varchar(15) as
IF(@groupName <> '')
        BEGIN
            SELECT p.* FROM EventSetupFunctionGroup, Product p
            WHERE FunctionCode COLLATE database_default = p.PRODUCT_MINOR COLLATE database_default
                AND GroupName = @groupName
                 AND EventCode = @eventCode
                AND EventCode COLLATE database_default = p.PRODUCT_MAJOR COLLATE database_default
            ORDER BY FunctionOrder
        END
    ELSE
        BEGIN
            SELECT p.* FROM EventSetupFunctionGroup, Product p
            WHERE FunctionCode COLLATE database_default = p.PRODUCT_MINOR COLLATE database_default
                AND EventCode = @eventCode
                AND EventCode COLLATE database_default = p.PRODUCT_MAJOR COLLATE database_default
            ORDER BY FunctionOrder
        END

GO